//ÇÔ¼ö µî·Ï ºÎ ========================================================
function echo_line($no, $row) {
global $d_main, $d_dep, $code, $main_no, $dep_no, $my_color, $icon, $a_border, $al_color, $ag_color,$scroll_color,
$a_cut, $thread, $down_no, $no_no, $writer_no, $date_no, $view_no, $admin_email, $opinion_num, $new_list, $vote_no;
$date = substr($row[date],0,10);
//Àα⵵ À̹ÌÁö¸¦ ³Ö±âÀ§ÇÑ ¼Ò½º
if($row[change_con]==a) $change_con="
";
elseif($row[change_con]==b) $change_con="
";
elseif($row[change_con]==b) $change_con="
";
//°ø°³¿©ºÎ¸¦ Çѱ۷ΠǥÇöÇϱâ À§ÇÑ ¼Ò½º
if($row[open]==y) $open="°ø°³"; else $open="ºñ°ø°³";
echo "
$row[cafe_name] |
¹æ½Ä : $open |
Æ÷ÀÎÆ® : $row[reserve] ($change_con) |
·¹º§ : $row[level] |
ȸ¿ø : $row[member_num] |
°³¼³ÀÏ : $date |
$row[introduce]
|
|
";
}
// ========================================================ÇÔ¼ö µî·Ï ºÎ
//cafe_list.html¿¡ »Ñ·ÁÁÙ °Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â
if(empty($cafe_array)) $cafe_array=cafe_date;
if(strlen($keyword) > 0)
{
switch ($ftype) {
case "subj":
$colm = cafe_name;
break;
case "cont":
$colm = introduce;
break;
case "name":
$colm = nickname;
break;
}
$sql="select * from user where
$colm like '%$keyword%'
order by $cafe_array desc";
}
else
$sql="select * from user where branch='$branch_no'
order by $cafe_array desc";
$result = mysql_query($sql);
//manager_passÅ×ÀÌºí¿¡¼ µ¥ÀÌŸ¸¦ ºÒ·¯ ½Ã°£À» ºñ±³ÇØ userÅ×À̺í°ú manager_passÅ×À̺íÀ» ¾÷µ¥ÀÌÆ®ÇÑ´Ù.
//¸¸¾à Ç϶ô,À¯Áö,»ó½ÂÀÇ ´ëÇÑ Á¶°ÇÀ» ¹Ù²Ù°í ½ÍÀ¸¸é ¾Æ·¡ ¼ýÀÚ¸¦ ¹Ù²ãÁÖ¸é µÈ´Ù.(¾÷µ¥ÀÌÆ® ³¯Â¥*¼ýÀÚ)
if((time()-$c_row[pre_time]) >= ($c_row[date_gap]*86400)) {
$pre_time=time();
mysql_query("update manager_pass set pre_time=$pre_time");
while($row=mysql_fetch_array($result)) {
$point_gap=$row[reserve]-$row[pre_reserve];
if(($c_row[date_gap]*10)>$point_gap) $change_con="a";
elseif(($c_row[date_gap]*10)<=$point_gap and $point_gap<($c_row[date_gap]*50)) $change_con="b";
elseif(($c_row[date_gap]*50)<=$point_gap) $change_con="c";
mysql_query("update user set pre_reserve=$row[reserve],change_con='$change_con' where id='$row[id]'");
}
mysql_data_seek($result,0);
}
$colm ="";
//ÇÑȸ鿡 Ãâ·ÂÇÒ ÁÙ ¼ö
$rows = $a_rows;
//ÇÑ È¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö
$page_scale = $a_page;
// Àüü±Û ¸ñ·Ï ¼ö
$count = mysql_num_rows($result);
// ÇöÀç º¸¿©ÁÖ´Â ÆäÀÌÁö¹øÈ£
if (empty($page)) $page = 1;
// ÇöÀç ÆäÀÌÁö¿¡ µû¸¥ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ Ã¹ À§Ä¡
$start=($page-1)*$rows;
// °á°ú Áß¿¡¼ ÇöÀç ÆäÀÌÁöÀÇ Ã¹¹øÂ° ·¹ÄÚµå¼ÂÀ¸·Î À̵¿ÇÑ´Ù.
if ($start > 1) mysql_data_seek($result,$start);
// ÃÑ ÆäÀÌÁö¼ö
$total = ceil(($count)/$rows);
?>
>
¢¾=$branch_no?> Ä«Å×°í¸®¿¡ µî·ÏµÈ Ä«Æä´Â =$count?> °³ |
|
|
|
//¸ñ·Ï±ÛÀ» Ãâ·ÂÇϱâ À§ÇÑ ·çƾ
$line = 0;
while($row = mysql_fetch_array($result))
{
//¹øÈ£
$no = $count-$start-$line;
//°Ô½Ã¸ñ·Ï Ãâ·Â
echo_line($no,$row);
//Ãâ·ÂµÈ °Ô½Ã¹°ÀÇ ¼ö¿Í ÇÑȸ鿡 º¸¿©ÁÙ ÁÙ¼ö¿Í ºñ±³
if(++$line==$rows) break;
}
// °Ô½Ã¹°ÀÌ ¾ø´Â °æ¿ì
if ($count == 0)
echo "
µî·ÏµÈ Ä«Æä°¡ ¾ø½À´Ï´Ù.
|
\n";
?>
|
include("../../inc_file/list/page.php"); ?>
|
|